﻿CREATE PROCEDURE dbo.SP_MemberCommitties_UPDATE
												@Church NVarChar 							(256)  =  NULL 
														, @CommittieID Int 							  =  NULL 
														, @DayOfMonth TinyInt 							  =  NULL 
														, @DayOfWeek TinyInt 							  =  NULL 
														, @IsServant Bit 							  =  NULL 
														, @MemberId Int 							  =  NULL 
														, @Name NVarChar 							(256)  =  NULL 
														, @OccurreEveryMonths TinyInt 							  =  NULL 
														, @OccurreEveryWeeks Int 							  =  NULL 
														, @OccurrenceType TinyInt 							  =  NULL 
														, @ServantType NVarChar 							(256)  =  NULL 
														, @TimeOfWeek DateTime 							  =  NULL 
														, @WeekOfMonth TinyInt 							  =  NULL 
												AS
					UPDATE MemberCommitties SET
													Church=@Church 
																,DayOfMonth=@DayOfMonth
																,DayOfWeek=@DayOfWeek
																,IsServant=@IsServant
																,MemberId=@MemberId
																,Name=@Name
																,OccurreEveryMonths=@OccurreEveryMonths
																,OccurreEveryWeeks=@OccurreEveryWeeks
																,OccurrenceType=@OccurrenceType
																,ServantType=@ServantType
																,TimeOfWeek=@TimeOfWeek
																,WeekOfMonth=@WeekOfMonth
													Where 	
												CommittieID=@CommittieID
							